Column

Structure of the amount per month paid

Table specification

Month Date Amortization Interest (%) Loan to pay Loan paid Loan paid (%) Interest Amortization (%) Pay per month
1 Oct 2018 2’583 1.38 1’550’000 0 0.0 1’782.50 1.99974 4’365.50
2 Nov 2018 2’583 1.38 1’547’417 2’583 0.2 1’779.53 2.00308 4’362.53
3 Dec 2018 2’583 1.38 1’544’834 5’166 0.3 1’776.56 2.00643 4’359.56
4 Jan 2019 2’583 1.38 1’542’251 7’749 0.5 1’773.59 2.00979 4’356.59
5 Feb 2019 2’583 1.38 1’539’668 10’332 0.7 1’770.62 2.01316 4’353.62
6 Mar 2019 2’583 1.38 1’537’085 12’915 0.8 1’767.65 2.01654 4’350.65
7 Apr 2019 2’583 1.38 1’534’502 15’498 1.0 1’764.68 2.01994 4’347.68

Column

Loan paid (Percentage)

My address